const Sequelize = require('sequelize')
let db = require('../config/db')


let User_info = db.define('user_info',{
    id:{
        type: Sequelize.INTEGER,
        primaryKey:true,
        autoIncrement: true,
        comment: "主键，自增"
    },
    uid:{
        type:Sequelize.INTEGER
    },
    uname:{
        type:Sequelize.STRING,
    },
    wechat:{
        type:Sequelize.STRING,
    },
    qq:{
        type:Sequelize.STRING,
    },
    sex:{
        type:Sequelize.STRING,
    },
    age:{
        type:Sequelize.STRING,
    },
    contact:{
        type:Sequelize.STRING
    },
    isDel:{
        type: Sequelize.INTEGER,
        defaultValue:0,
        comment:'状态，是否删除'
    }
},{
    freezeTableName:true,
    paranoid:true,
    timestamps:true
})
let user_info = User_info.sync();

module.exports = User_info
